from sqlalchemy import Column, Integer, String, DateTime
from config.database import Base
from datetime import datetime


class CasdoorUser(Base):
    """
    用户信息表
    """
    __tablename__ = 'user'

    owner = Column(String(100), primary_key=True)
    name = Column(String(100), primary_key=True)
    created_time = Column(String(100))
    updated_time = Column(String(100))
    deleted_time = Column(String(100))
    id = Column(String(100))
    external_id = Column(String(100))
    type = Column(String(100))
    password = Column(String(150))
    password_salt = Column(String(100))
    password_type = Column(String(100))
    display_name = Column(String(100))
    first_name = Column(String(100))
    last_name = Column(String(100))
    avatar = Column(String(100))
    avatar_type = Column(String(100))
    permanent_avata = Column(String(100))
    email = Column(String(100))
    email_verified = Column(String(100))
    phone = Column(String(100))
    country_code = Column(String(100))
    region = Column(String(100))
    location = Column(String(100))
    address = Column(String(100))
    affiliation = Column(String(100))
    title = Column(String(100))
    id_card_type = Column(String(100))
    id_card = Column(String(100))
    homepage = Column(String(100))
    bio = Column(String(100))
    tag = Column(String(100))
    language = Column(String(100))
    gender = Column(String(100))
    birthday = Column(String(100))
    education = Column(String(100))
    score = Column(String(100))
    karma = Column(String(100))
    ranking = Column(String(100))
    balance = Column(String(100))
    currency = Column(String(100))
    is_default_avat = Column(String(100))
    is_online = Column(String(100))
    is_admin = Column(String(100))
    is_forbidden = Column(String(100))
    is_deleted = Column(String(100))
    signup_applicat = Column(String(100))
    hash = Column(String(100))
    pre_hash = Column(String(100))
    access_key = Column(String(100))
    access_secret = Column(String(100))
    access_token = Column(String(100))
    created_ip = Column(String(100))
    last_signin_tim = Column(String(100))
    last_signin_ip = Column(String(100))
    github = Column(String(100))
    google = Column(String(100))
    qq = Column(String(100))
    wechat = Column(String(100))
    facebook = Column(String(100))
    dingtalk = Column(String(100))
    weibo = Column(String(100))
    gitee = Column(String(100))
    linkedin = Column(String(100))
    wecom = Column(String(100))
    lark = Column(String(100))
    gitlab = Column(String(100))
    adfs = Column(String(100))
    baidu = Column(String(100))
    alipay = Column(String(100))
    casdoor = Column(String(100))
    infoflow = Column(String(100))
    apple = Column(String(100))
    azuread = Column(String(100))
    azureadb2c = Column(String(100))
    slack = Column(String(100))
    steam = Column(String(100))
    bilibili = Column(String(100))
    okta = Column(String(100))
    douyin = Column(String(100))
    line = Column(String(100))
    amazon = Column(String(100))
    auth0 = Column(String(100))
    battlenet = Column(String(100))
    bitbucket = Column(String(100))
    box = Column(String(100))
    cloudfoundry = Column(String(100))
    dailymotion = Column(String(100))
    deezer = Column(String(100))
    digitalocean = Column(String(100))
    discord = Column(String(100))
    dropbox = Column(String(100))
    eveonline = Column(String(100))
    fitbit = Column(String(100))
    gitea = Column(String(100))
    heroku = Column(String(100))
    influxcloud = Column(String(100))
    instagram = Column(String(100))
    intercom = Column(String(100))
    kakao = Column(String(100))
    lastfm = Column(String(100))
    mailru = Column(String(100))
    meetup = Column(String(100))
    microsoftonline = Column(String(100))
    naver = Column(String(100))
    nextcloud = Column(String(100))
    onedrive = Column(String(100))
    oura = Column(String(100))
    patreon = Column(String(100))
    paypal = Column(String(100))
    salesforce = Column(String(100))
    shopify = Column(String(100))
    soundcloud = Column(String(100))
    spotify = Column(String(100))
    strava = Column(String(100))
    stripe = Column(String(100))
    tiktok = Column(String(100))
    tumblr = Column(String(100))
    twitch = Column(String(100))
    twitter = Column(String(100))
    typetalk = Column(String(100))
    uber = Column(String(100))
    vk = Column(String(100))
    wepay = Column(String(100))
    xero = Column(String(100))
    yahoo = Column(String(100))
    yammer = Column(String(100))
    yandex = Column(String(100))
    zoom = Column(String(100))
    metamask = Column(String(100))
    web3onboard = Column(String(100))
    custom = Column(String(100))
    webauthnCredent = Column(String(100))
    preferred_mfa_t = Column(String(100))
    recovery_codes = Column(String(100))
    totp_secret = Column(String(100))
    mfa_phone_enabl = Column(String(100))
    mfa_email_enabl = Column(String(100))
    invitation = Column(String(100))
    invitation_code = Column(String(100))
    face_ids = Column(String(100))
    ldap = Column(String(100))
    properties = Column(String(100))
    roles = Column(String(100))
    permissions = Column(String(100))
    groups = Column(String(100))
    last_signin_wro = Column(String(100))
    signin_wrong_ti = Column(String(100))
    managedAccounts = Column(String(100))